Tabela GPSubscriptionHist

Definicja tabeli GPSubscriptionHist

Name

GPSubscriptionHist

Code

GPSubscriptionHist

Comment

 


Lista kolumn tabeli GPSubscriptionHist

Name

Code

GPSubscriptionID

GPSubscriptionID

StartDT

StartDT

StopDT

StopDT

Comments

Comments

Active

Active

IsMilitaryServicePlace

IsMilitaryServicePlace

IsBaseOfPayment

IsBaseOfPayment

IdentificationDocumentNo

IdentificationDocumentNo

FluoridePrevention

FluoridePrevention

Version

Version

ProblemsDesc

ProblemsDesc

ServiceRangeCode

ServiceRangeCode

DistinguishingMark

DistinguishingMark

ServCode

ServCode

InsertDate

InsertDate

InsertingPerson

InsertingPerson

GPSubscriptionTypeID

GPSubscriptionTypeID

OrgUnitID

OrgUnitID

PersonID

PersonID

PatientID

PatientID

SchoolID

SchoolID

IdentificationTypeID

IdentificationTypeID

PupilCategoryID

PupilCategoryID

CategoryGPID

CategoryGPID


Kolumna GPSubscriptionID tabeli GPSubscriptionHist

Definicja kolumny GPSubscriptionID tabeli GPSubscriptionHist

Name

GPSubscriptionID

Code

GPSubscriptionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli GPSubscriptionHist

Definicja kolumny StartDT tabeli GPSubscriptionHist

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data i godzina rozpoczecia przepustki


Kolumna StopDT tabeli GPSubscriptionHist

Definicja kolumny StopDT tabeli GPSubscriptionHist

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data zakonczenia sesji lub cyklu leczenia


Kolumna Comments tabeli GPSubscriptionHist

Definicja kolumny Comments tabeli GPSubscriptionHist

Name

Comments

Code

Comments

Data Type

VARCHAR2(1024)

Mandatory

No

Comment

 


Kolumna Active tabeli GPSubscriptionHist

Definicja kolumny Active tabeli GPSubscriptionHist

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IsMilitaryServicePlace tabeli GPSubscriptionHist

Definicja kolumny IsMilitaryServicePlace tabeli GPSubscriptionHist

Name

IsMilitaryServicePlace

Code

IsMilitaryServicePlace

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IsBaseOfPayment tabeli GPSubscriptionHist

Definicja kolumny IsBaseOfPayment tabeli GPSubscriptionHist

Name

IsBaseOfPayment

Code

IsBaseOfPayment

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IdentificationDocumentNo tabeli GPSubscriptionHist

Definicja kolumny IdentificationDocumentNo tabeli GPSubscriptionHist

Name

IdentificationDocumentNo

Code

IdentificationDocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FluoridePrevention tabeli GPSubscriptionHist

Definicja kolumny FluoridePrevention tabeli GPSubscriptionHist

Name

FluoridePrevention

Code

FluoridePrevention

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Version tabeli GPSubscriptionHist

Definicja kolumny Version tabeli GPSubscriptionHist

Name

Version

Code

Version

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ProblemsDesc tabeli GPSubscriptionHist

Definicja kolumny ProblemsDesc tabeli GPSubscriptionHist

Name

ProblemsDesc

Code

ProblemsDesc

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna ServiceRangeCode tabeli GPSubscriptionHist

Definicja kolumny ServiceRangeCode tabeli GPSubscriptionHist

Name

ServiceRangeCode

Code

ServiceRangeCode

Data Type

VARCHAR2(14)

Mandatory

No

Comment

Ustalony przez platnika kod zakresu swiadczen ze slownika platnika. (Zakres swiadczen- dawniej nazywany 'produktem kontraktowym' ustalany przez platnika na podstawie przekazanych danych deklaracji (tzw.czynników stawki))


Kolumna DistinguishingMark tabeli GPSubscriptionHist

Definicja kolumny DistinguishingMark tabeli GPSubscriptionHist

Name

DistinguishingMark

Code

DistinguishingMark

Data Type

NUMBER(10)

Mandatory

No

Comment

Wyróznik (wariant) zakresu swiadczen. (Wystepuje tylko wtedy, gdy zakres swiadczen posiada zdefiniowane wyrózniki)


Kolumna ServCode tabeli GPSubscriptionHist

Definicja kolumny ServCode tabeli GPSubscriptionHist

Name

ServCode

Code

ServCode

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Kod swiadczenia z katalogu platnika. (swiadczenie z katalogu platnika dawniej bylo nazywane 'produktem jednostkowym')


Kolumna InsertDate tabeli GPSubscriptionHist

Definicja kolumny InsertDate tabeli GPSubscriptionHist

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli GPSubscriptionHist

Definicja kolumny InsertingPerson tabeli GPSubscriptionHist

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna GPSubscriptionTypeID tabeli GPSubscriptionHist

Definicja kolumny GPSubscriptionTypeID tabeli GPSubscriptionHist

Name

GPSubscriptionTypeID

Code

GPSubscriptionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrgUnitID tabeli GPSubscriptionHist

Definicja kolumny OrgUnitID tabeli GPSubscriptionHist

Name

OrgUnitID

Code

OrgUnitID

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna PersonID tabeli GPSubscriptionHist

Definicja kolumny PersonID tabeli GPSubscriptionHist

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientID tabeli GPSubscriptionHist

Definicja kolumny PatientID tabeli GPSubscriptionHist

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SchoolID tabeli GPSubscriptionHist

Definicja kolumny SchoolID tabeli GPSubscriptionHist

Name

SchoolID

Code

SchoolID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IdentificationTypeID tabeli GPSubscriptionHist

Definicja kolumny IdentificationTypeID tabeli GPSubscriptionHist

Name

IdentificationTypeID

Code

IdentificationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PupilCategoryID tabeli GPSubscriptionHist

Definicja kolumny PupilCategoryID tabeli GPSubscriptionHist

Name

PupilCategoryID

Code

PupilCategoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CategoryGPID tabeli GPSubscriptionHist

Definicja kolumny CategoryGPID tabeli GPSubscriptionHist

Name

CategoryGPID

Code

CategoryGPID

Data Type

NUMBER(10)

Mandatory

No

Comment